# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月20日
"""
import openpyxl

myBook = openpyxl.load_workbook('收入表.xlsx',data_only=True)
mySheet=myBook.active
myRows=mySheet.rows
myNewBook=openpyxl.Workbook()
myNewSheet=myNewBook.active
myNewSheet.title='收入表'
for myRow in myRows:
	myList=[]
	for myCell in myRow:
		myList+=[myCell.value]
	myNewSheet.append(myList)
myNewBook.save('结果表-收入表.xlsx')

